CREATE USER [USERNAME] IDENTIFIED BY "[USERNAME]" DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;

GRANT GST_GROUP TO [USERNAME];

ALTER USER [USERNAME] QUOTA 4G ON users; 

ALTER USER [USERNAME] QUOTA 1G ON indx;

GRANT CREATE SESSION TO [USERNAME];

GRANT CREATE TABLE TO [USERNAME];

GRANT CREATE VIEW TO [USERNAME];

GRANT CREATE SEQUENCE TO [USERNAME];

GRANT CREATE TYPE TO [USERNAME];

GRANT CREATE /*ANY*/ TRIGGER TO [USERNAME];

CREATE SEQUENCE [USERNAME].USER_SERIAL;
GRANT SELECT ON [USERNAME].USER_SERIAL TO GST;